CREATE procedure [dbo].[BAEEventSetupAddGuest] @EventCode varchar(15),
      @pageMessage varchar(255),
      @FirstName varchar(25) ,
      @FirstNameEnabled bit ,
      @FirstNameRequired bit ,
      @MiddleInitial varchar(25) ,
      @MiddleInitialEnabled bit ,
      @MiddleInitialRequired bit ,
      @LastName varchar(25) ,
      @LastNameEnabled bit ,
      @LastNameRequired bit ,
      @Address varchar(25) ,
      @AddressEnabled bit ,
      @AddressRequired bit ,
      @City varchar(25) ,
      @CityEnabled bit ,
      @CityRequired bit ,
      @State varchar(25) ,
      @StateEnabled bit ,
      @StateRequired bit,
      @PostalCode varchar(25),
      @PostalCodeEnabled bit,
      @PostalCodeRequired bit,
      @Country varchar(25),
      @CountryEnabled bit,
      @CountryRequired bit,
      @Prefix varchar(25),
      @PrefixEnabled bit,
      @PrefixRequired bit,
      @Suffix varchar(25),
      @SuffixEnabled bit,
      @SuffixRequired bit,
      @Nickname varchar(25),
      @NicknameEnabled bit,
      @NicknameRequired bit,      
      @Designation varchar(25),
      @DesignationEnabled bit,
      @DesignationRequired bit,      
      @Title varchar(25),
      @TitleEnabled bit,
      @TitleRequired bit,  
      @Company varchar(25),
      @CompanyEnabled bit,
      @CompanyRequired bit as

SELECT * FROM EventSetupGuest
      WHERE EventCode = @EventCode;

      IF(@@RowCount > 0)
            BEGIN
                  UPDATE EventSetupGuest
                        SET GuestPageMessage = @pageMessage, FirstName = @FirstName, FirstNameEnabled = @FirstNameEnabled, FirstNameRequired = @FirstNameRequired, MiddleInitial = @MiddleInitial, MiddleInitialEnabled = @MiddleInitialEnabled, MiddleInitialRequired = @MiddleInitialRequired, LastName = @LastName, LastNameEnabled = @LastNameEnabled, LastNameRequired = @LastNameRequired, Address = @Address, AddressEnabled = @AddressEnabled, AddressRequired = @AddressRequired, City = @City, CityEnabled = @CityEnabled, CityRequired = @CityRequired, StateProvince = @State, StateEnabled = @StateEnabled, StateRequired = @StateRequired, PostalCode =@PostalCode, PostalCodeEnabled = @PostalCodeEnabled, @PostalCodeRequired = PostalCodeRequired, Country = @Country, CountryEnabled = @CountryEnabled, CountryRequired = @CountryRequired, Prefix = @Prefix, PrefixEnabled = @PrefixEnabled, PrefixRequired = @PrefixRequired, Suffix = @Suffix, SuffixEnabled = @SuffixEnabled, SuffixRequired = @SuffixRequired, Nickname = @Nickname, NicknameEnabled = @NicknameEnabled, NicknameRequired = @NicknameRequired, Designation = @Designation, DesignationEnabled = @DesignationEnabled, DesignationRequired = @DesignationRequired, Title = @Title, TitleEnabled = @TitleEnabled, TitleRequired = @TitleRequired, Company = @Company, CompanyEnabled = @CompanyEnabled, CompanyRequired = @CompanyRequired
                  WHERE EventCode = @EventCode;
            END
      ELSE
            BEGIN
                  INSERT INTO EventSetupGuest
                        VALUES(@EventCode, @pageMessage, @FirstName, @FirstNameEnabled, @FirstNameRequired, @MiddleInitial,@MiddleInitialEnabled, @MiddleInitialRequired, @LastName, @LastNameEnabled, @LastNameRequired, @Address, @AddressEnabled, @AddressRequired, @City, @CityEnabled, @CityRequired, @State, @StateEnabled, @StateRequired, @PostalCode, @PostalCodeEnabled , @PostalCodeRequired, @Country, @CountryEnabled, @CountryRequired, @Prefix, @PrefixEnabled, @PrefixRequired, @Suffix, @SuffixEnabled, @SuffixRequired, @Nickname, @NicknameEnabled, @NicknameRequired, @Designation, @DesignationEnabled, @DesignationRequired,    @Title, @TitleEnabled, @TitleRequired, @Company, @CompanyEnabled, @CompanyRequired)
            END

GO